﻿<%@ Page Title="" Language="C#" MasterPageFile="~/adminpanel.master" AutoEventWireup="true" CodeFile="Distributor_Sales_Report.aspx.cs" Inherits="Web_Distributor_Sales_Report" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
   
   
    <style type="text/css">
        .style2
        {
            width: 81px;
        }
        .style3
        {
            width: 94px;
        }
        .style4
        {
            width: 72px;
        }
    </style>
   
   
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

    <table width="100%" >
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <b></b></td>
            <td  >
                &nbsp;</td>
            <td class="style3"  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2" >
                &nbsp;</td>
            <td >
                <dx:ASPxLabel ID="ASPxLabel3" runat="server" Font-Bold="True" 
                    Font-Names="Tahoma" ForeColor="#0000CC" Text="Report By:" 
                    CssClass="tabListMenuItem">
                </dx:ASPxLabel>
            </td>
            <td  >
                &nbsp;</td>
            <td class="style3" >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <dx:ASPxRadioButton ID="ASPxRadioButton1" runat="server" Text="Invoice Date" 
                    AutoPostBack="True" GroupName="invoice" 
                    oncheckedchanged="ASPxRadioButton1_CheckedChanged" Height="17px">
                </dx:ASPxRadioButton>
            </td>
            <td align="right" >
                <asp:Label ID="Label5" runat="server" Text="From"></asp:Label>
            </td>
            <td class="style3"  >
                <dx:ASPxDateEdit ID="ASPxDateEdit1" runat="server" ClientIDMode="AutoID" 
                    CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                    SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="100px">
                    <CalendarProperties>
                        <HeaderStyle Spacing="1px" />
                        <FooterStyle Spacing="4px" />
                    </CalendarProperties>
                    <ButtonStyle Width="11px">
                    </ButtonStyle>
                    <ValidationSettings ErrorDisplayMode="Text" ErrorText="Please Select Date" 
                        ErrorTextPosition="Bottom">
                        <ErrorFrameStyle ImageSpacing="4px">
                            <ErrorTextPaddings PaddingLeft="4px" />
                        </ErrorFrameStyle>
                        <RequiredField ErrorText="Please Select Date" IsRequired="True" />
                    </ValidationSettings>
                </dx:ASPxDateEdit>
            </td>
            <td align="right"  >
                <asp:Label ID="Label6" runat="server" Text="To"></asp:Label>
            </td>
            <td  >
                <dx:ASPxDateEdit ID="ASPxDateEdit2" runat="server" ClientIDMode="AutoID" 
                    CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                    SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="100px">
                    <CalendarProperties>
                        <HeaderStyle Spacing="1px" />
                        <FooterStyle Spacing="4px" />
                    </CalendarProperties>
                    <ButtonStyle Width="11px">
                    </ButtonStyle>
                    <ValidationSettings ErrorTextPosition="Bottom">
                        <ErrorFrameStyle ImageSpacing="4px">
                            <ErrorTextPaddings PaddingLeft="4px" />
                        </ErrorFrameStyle>
                        <RequiredField ErrorText="Please Select Date" IsRequired="True" />
                    </ValidationSettings>
                </dx:ASPxDateEdit>
            </td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <dx:ASPxRadioButton ID="ASPxRadioButton2" runat="server" Text="Invoice ID" 
                    AutoPostBack="True" GroupName="invoice" 
                    oncheckedchanged="ASPxRadioButton2_CheckedChanged">
                </dx:ASPxRadioButton>
            </td>
            <td>
                <asp:Label ID="Label2" runat="server" Text="Select Invoice ID"></asp:Label>
            </td>
            <td class="style3">
                <asp:DropDownList ID="DropDownList1" runat="server" 
                    DataSourceID="SqlDataSource1" DataTextField="Pur_ID" DataValueField="Pur_ID" 
                    Width="100px">
                </asp:DropDownList>
            </td>
            <td  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <dx:ASPxRadioButton ID="ASPxRadioButton3" runat="server" Text="Product" 
                    AutoPostBack="True" GroupName="invoice" 
                    oncheckedchanged="ASPxRadioButton3_CheckedChanged">
                </dx:ASPxRadioButton>
            </td>
            <td  >
                <asp:Label ID="Label3" runat="server" Text="Select Product Name"></asp:Label>
            </td>
            <td class="style3"  >
                <asp:DropDownList ID="DropDownList2" runat="server" 
                    DataSourceID="SqlDataSource2" DataTextField="Pro_Name" DataValueField="Pro_ID" 
                    Width="100px">
                </asp:DropDownList>
            </td>
            <td  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <dx:ASPxRadioButton ID="ASPxRadioButton4" runat="server" Text="Distributor " 
                    AutoPostBack="True" GroupName="invoice" 
                    oncheckedchanged="ASPxRadioButton4_CheckedChanged">
                </dx:ASPxRadioButton>
            </td>
            <td  >
                <asp:Label ID="Label4" runat="server" Text="Select Distributor Name"></asp:Label>
            </td>
            <td class="style3"  >
                <asp:DropDownList ID="DropDownList5" runat="server" 
                    DataSourceID="SqlDataSource3" DataTextField="Giv_Name" 
                    DataValueField="Giv_Name" Width="100px">
                </asp:DropDownList>
            </td>
            <td  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2" >
                &nbsp;</td>
            <td >
                <b></b></td>
            <td  >
                &nbsp;</td>
            <td class="style3" >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <dx:ASPxLabel ID="ASPxLabel4" runat="server" Font-Bold="True" 
                    Font-Names="Tahoma" ForeColor="#0000CC" 
                    Text="Select  Status of the Invoice" CssClass="tabListMenuItem">
                </dx:ASPxLabel>
                <b>:</b></td>
            <td  >
                <asp:DropDownList ID="DropDownList4" runat="server" Width="150px">
                    <asp:ListItem Value="None">None</asp:ListItem>
                    <asp:ListItem Value="Issued">Issued</asp:ListItem>
                    <asp:ListItem Value="Not Issued">Not Issued</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td class="style3"  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <b></b></td>
            <td  >
                &nbsp;</td>
            <td class="style3" >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2"  >
                &nbsp;</td>
            <td >
                <dx:ASPxButton ID="ASPxButton1" runat="server" ClientIDMode="AutoID" 
                    CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                    SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    Text="Generate Report" onclick="ASPxButton1_Click">
                </dx:ASPxButton>
            </td>
            <td  >
                &nbsp;</td>
            <td class="style3"  >
                &nbsp;</td>
            <td  >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td >
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    <table >
        <tr>
            <td >
                &nbsp;</td>
            <td width="100%">
                <table >
                    <tr>
                        <td class="style4" >
                            &nbsp;</td>
                        <td>
                <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
                    AutoDataBind="true" EnableDatabaseLogonPrompt="False" ToolPanelView="None" 
                                HasCrystalLogo="False" />
                        </td>
                    </tr>
                    <tr>
                        <td class="style4" >
                            &nbsp;</td>
                        <td>
                            &nbsp;</td>
                    </tr>
                </table>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                    SelectCommand="SELECT [Pro_ID], [Pro_Name] FROM [Tbl_Product]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                    SelectCommand="SELECT [Giv_Name] FROM [Tbl_Distributor]">
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td >
                &nbsp;</td>
            <td width="100%">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                    SelectCommand="SELECT [Pur_ID] FROM [Tbl_UserPurchase]"></asp:SqlDataSource>
                </td>
        </tr>
    </table>

</asp:Content>

